package com.itheima.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;

@Mapper
public interface ReportMapper {
    /**
     * 获取到截至日期时的会员数量
     * @param monthDay
     * @return
     */
    @Select("select count(*) from vip where create_time < #{monthDay}")
    Integer getMemberReport(LocalDate monthDay);
}
